<template>
    <div class="app-container">

        <!--搜索表单-->
        <el-form :inline="true" :model="searchStudent" class="demo-form-inline">
            <el-form-item label="姓名">
                <el-input
                    v-model="searchStudent.name"
                    placeholder="请输入学员姓名"
                />
            </el-form-item>
            <el-form-item label="学号">
                <el-input
                    v-model="searchStudent.number"
                    placeholder="请输入学员学号"
                />
            </el-form-item>
            <el-form-item label="入学年份">
                <el-date-picker
                    v-model="searchStudent.entry"
                    value-format="yyyy"
                    type="year"
                    placeholder="请选择入学年份"
                >
                </el-date-picker>
            </el-form-item>

            <el-form-item>
                <el-button type="primary" @click="onSubmit">查询</el-button>
                <el-button type="info" @click="clear">清空</el-button>
            </el-form-item>
        </el-form>

        <!--按钮-->
        <el-row>
            <el-button type="danger" size="medium" @click="deleteByIds">- 批量删除</el-button>
            <el-button type="primary" size="medium" @click="dialogVisible = true; student = {};">+ 新增学员</el-button>
          <el-button type="primary" size="medium" @click="exportExcelFile" >导出表格</el-button>
          <el-button type="primary" size="medium" @click="importExcelFile" >导入表格</el-button>
          <input type="file" ref="excelFileInput" accept=".xls,.xlsx" style="display: none;" @change="handleExcelFileChange" />
        </el-row>

        <!--添加数据对话框表单-->
        <el-dialog ref="form" title="编辑学员" :visible.sync="dialogVisible" width="30%">
            <el-form ref="form" :model="student" label-width="80px" size="mini">
                <el-form-item label="学号">
                    <el-input v-model="student.number"/>
                </el-form-item>
                <el-form-item label="学员姓名">
                    <el-input v-model="student.name"/>
                </el-form-item>

                <el-form-item label="性别">
                    <el-select v-model="student.gender" placeholder="请选择" style="width:100%">
                        <el-option
                            v-for="item in genderList"
                            :key="item.value"
                            :label="item.name"
                            :value="item.id"
                        />
                    </el-select>
                </el-form-item>

                <el-form-item label="班级">
                    <el-select v-model="student.clazzId" placeholder="请选择" value-key="student.job"
                               style="width:100%"
                    >
                        <el-option
                            v-for="item in clazzOpts"
                            :key="item.id"
                            :label="item.name"
                            :value="item.id"
                        />
                    </el-select>
                </el-form-item>
                <el-form-item label="入学年份">
                    <el-date-picker
                        v-model="student.entry"
                        type="year"
                        value-format="yyyy"
                        placeholder="请选择入学年份"
                    >
                    </el-date-picker>
                </el-form-item>

                <el-form-item>
                    <el-button type="primary" @click="add">提交</el-button>
                    <el-button @click="dialogVisible = false">取消</el-button>
                </el-form-item>
            </el-form>
        </el-dialog>

        <br>
        <!--表格-->
        <template>
            <el-table :data="tableData" style="width: 100%" border @selection-change="handleSelectionChange">
                <el-table-column type="selection" width="55" align="center"/>
                <el-table-column prop="number" label="学号" align="center"/>
                <el-table-column prop="name" label="姓名" align="center"/>

                <el-table-column align="center" label="性别">
                    <template slot-scope="scope">
            <span style="margin-right: 10px">
              {{ scope.row.gender == '1' ? '男' : '女' }}</span>
                    </template>
                </el-table-column>

                <el-table-column prop="clazzName" align="center" label="班级"/>
                <el-table-column prop="entry" label="入学年份" align="center"/>

                <el-table-column align="center" label="最后操作时间">
                    <template slot-scope="scope">
                        {{ dayjs(scope.row.updateTime).format('YYYY-MM-DD HH:mm:ss') }}
                    </template>
                </el-table-column>

                <el-table-column align="center" label="操作">
                    <template slot-scope="scope">
                        <el-button type="primary" size="small" @click="update(scope.row.id)">编辑</el-button>
                        <el-button type="danger" size="small" @click="deleteById(scope.row.id)">删除</el-button>
                    </template>
                </el-table-column>
            </el-table>
        </template>

        <!--分页工具条-->
        <el-pagination
            :background="background"
            :current-page="searchStudent.pageNum"
            :limit.sync="searchStudent.pageSize"
            :page-sizes="[5, 10, 15, 20]"
            :page-size="10"
            layout="total, sizes, prev, pager, next, jumper"
            :total="totalCount"
            @size-change="handleSizeChange"
            @current-change="handleCurrentChange"
        />
    </div>
</template>

<script>
import { page, add, update, deleteById, selectById, exportExcel, importExcel } from '@/api/student.js'
import { page as clazzList} from '@/api/clazz.js'
import {findAll} from '@/api/dept.js'
import { getToken } from '@/utils/auth'
import dayjs from 'dayjs'

export default {
    data() {
        return {
            background: true,
            // 总记录数
            totalCount: 100,
            // 添加数据对话框是否展示的标记
            dialogVisible: false,
            // 学员查询数据
            searchStudent: {
                name: '',
                gender: '',
                entry: '',
                pageNum: 1,
                pageSize: 10
            },
            student: {
                id: '',
                number: '',
                name: null,
                gender: null,
                clazzId: null,
                clazzName: null,
                entry: null,
                status: null,
                phone: null,
                address: null,
            },
            studentList: [],
            genderList: [{ id: 1, name: '男' }, { id: 2, name: '女' }],
            clazzOpts: [],
            beginTime: '',
            // 被选中的id数组
            selectedIds: [],
            // 复选框选中数据集合
            multipleSelection: [],
            // 表格数据
            tableData: [],
            token: { token: getToken() }
        }
    },

    mounted() {
        this.getClazzOpts()
        this.page() // 当页面加载完成后，发送异步请求，获取数据
        findAll().then((result) => {
            this.studentList = result.data
        })
    },

    methods: {
        dayjs,
        // 查询分页数据
        page() {
            page(this.searchStudent).then((res) => {
                console.log(res)
                this.totalCount = res.total
                this.tableData = res.rows
            })
        },
        getClazzOpts() {
            clazzList({}).then(res => {
                this.clazzOpts = res.rows.map((item) => {
                    return {
                        id: item.id,
                        name: item.professional + item.claz
                    }
                })
            })
        },
        // 复选框选中后执行的方法
        handleSelectionChange(val) {
            this.multipleSelection = val
        },

        // 查询方法
        onSubmit() {
            this.currentPage = 1
            this.page()
        },

        clear() {
            this.searchStudent = { name: '', gender: '' }
            this.beginTime = '',
                this.endTime = ''
            this.entrydate = ''
            this.page()
        },
        // 添加数据
        add() {
            let operator

            if (this.student.id) {
                // 修改
                operator = update(this.student)
            } else {
                operator = add(this.student)
            }
            console.log(this.student)
            operator.then((resp) => {
                this.dialogVisible = false
                this.page()
                this.$message({ message: '恭喜你，保存成功', type: 'success' })
                this.student = { image: '' }
            })
        },
        update(id) {
            // 1. 打开窗口
            this.dialogVisible = true
            // 2. 发送请求

            selectById(id).then((result) => {
                this.student = result.data
            })
        },

        // 分页
        handleSizeChange(val) {
            // 重新设置每页显示的条数
            this.searchStudent.pageSize = val
            this.page()
        },

        handleCurrentChange(val) {
            // 重新设置当前页码
            this.searchStudent.pageNum = val
            this.page()
        },

        // 删除学员信息
        deleteById(id) {
            this.$confirm('此操作将删除该数据, 是否继续?', '提示', {
                confirmButtonText: '确定',
                cancelButtonText: '取消',
                type: 'warning'
            }).then(() => {
                // 2. 发送AJAX请求
                deleteById(id).then((resp) => {
                    // 删除成功
                    this.$message.success('恭喜你，删除成功')
                    this.page()
                })
            }).catch(() => {
                // 用户点击取消按钮
                this.$message.info('已取消删除')
            })
        },

        // 批量删除学员信息
        deleteByIds() {
            // 弹出确认提示框
            this.$confirm('此操作将删除该数据, 是否继续?', '提示', {
                confirmButtonText: '确定',
                cancelButtonText: '取消',
                type: 'warning'
            }).then(() => {
                // 用户点击确认按钮
                // 1. 创建id数组, 从 this.multipleSelection 获取即可
                for (let i = 0; i < this.multipleSelection.length; i++) {
                    this.selectedIds[i] = this.multipleSelection[i].id
                }

                // 2. 发送AJAX请求
                deleteById(this.selectedIds).then((resp) => {
                    // 删除成功
                    this.$message.success('恭喜你，删除成功')
                    this.page()
                })
            }).catch(() => {
                // 用户点击取消按钮
                this.$message.info('已取消删除')
            })
        },
      exportExcelFile() {
        exportExcel().then(response => {
          const blob = new Blob(
            [response.data], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' });
          const url = window.URL.createObjectURL(blob);
          const link = document.createElement('a');
          link.href = url;
          link.download = '学员数据.xlsx';
          link.click();
          window.URL.revokeObjectURL(url);
        }).catch(error => {
          this.$message.error('导出失败：' + (error.response?.data?.msg || '网络错误'));
        });

      },
      // 导入Excel文件
      importExcelFile() {
        this.$refs.excelFileInput.click();
      },

      // 处理选择的Excel文件
      handleExcelFileChange(e) {
        const file = e.target.files[0];
        if (!file) return;
        // 验证文件类型
        const validTypes = ['application/vnd.ms-excel', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'];
        if (!validTypes.includes(file.type)) {
          this.$message.error('请上传Excel文件（.xls或.xlsx）');
          return;
        }
        // 创建FormData并上传
        const formData = new FormData();
        formData.append('file', file);
        importExcel(formData).then(res => {
          if (res.data.code == '200') {
            this.$message.success('班级数据导入成功');
            this.page(); // 刷新表格数据
          } else {
            this.$message.error(res.data.msg || '导入失败，请检查文件内容');
          }
          // 清空文件输入
          this.$refs.excelFileInput.value = '';
        }).catch(err => {
          this.$message.error('网络错误，导入失败');
        });
      },

    }
}
</script>
<style>
.avatar-uploader .el-upload {
    border: 1px dashed #d9d9d9;
    border-radius: 6px;
    cursor: pointer;
    position: relative;
    overflow: hidden;
}

.avatar-uploader .el-upload:hover {
    border-color: #409eff;
}

.avatar-uploader-icon {
    font-size: 28px;
    color: #8c939d;
    width: 100px;
    height: 100px;
    line-height: 100px;
    text-align: center;
}

.avatar {
    width: 100px;
    height: 100px;
    display: block;
}
</style>
